<?php
require_once(dirname(__FILE__)."/../../libs/dbclass/dbconnect.php");
class mysqlBackup{
	function backup(){
		mysql_query("set names 'utf8'");
		$mysql = "set charset utf8;\r\n";
		$q1 = mysql_query("show tables");
		while ($t = mysql_fetch_array($q1))
		{
			$table = $t[0];
			$q2 = mysql_query("show create table `$table`");
			$sql = mysql_fetch_array($q2);
			$mysql .="\r\n-- 表的名称 `article_class`\r\n";
			$mysql .= $sql['Create Table'] . ";\r\n";
			$mysql .="\r\n-- 导出数据 `article_class`\r\n";
			$q3 = mysql_query("select * from `$table`");
			while ($data = mysql_fetch_assoc($q3))
			{
				$keys = array_keys($data);
				$keys = array_map('addslashes', $keys);
				$keys = join('`,`', $keys);
				$keys = "`" . $keys . "`";
				$vals = array_values($data);
				$vals = array_map('addslashes', $vals);
				$vals = join("','", $vals);
				$vals = "'" . $vals . "'";
				$mysql .= "insert into `$table`($keys) values($vals);\r\n";
			} 
			$mysql .="\r\n-- --------------------------------------------------------\r\n\r\n";
		} 
		
		return $mysql;
	}
	
	
}	



?>

